Hi all ...
I've used a tracking sheet in Excel I developed to track my
letterboxes placed and found, exchanges, and gatherings.
I thought I'd share it with anyone who wants it.
The summary page will automatically calculate your finds by month
based on the starting date entered and the current date. The
individual tracking sheets will automatically number the boxes, etc.
To use this spreadsheet, simply fill in columns B through whatever
with your data. I've left the formula cells unlocked, but be sure not
to overwrite them!
To set your starting date (the month you began letterboxing), unhide
the hidden columns in the Summary spreadsheet and enter the the first
day of the month for the first month you started (for example, if you
started in August 2004, enter 8/1/04, even if you didn't start until
August 29) in Cell K9. Rehide the "hidden cells" by navigating to
Cell H4 and selecting hide cells.
Your spreadsheet is now ready for use.
If you like this spreadshet but have questions, feel free to ask.
CPAScott